package com.eportal.service;

import java.util.List;
import java.util.Map;

import com.eportal.domain.CRoom;
import com.eportal.domain.RoomUser;
import com.framework.excelTools.ExcelException;
import com.framework.jqgrid.JqGridPager;


public interface CRoomService {

	List<CRoom> list(JqGridPager jqGridPager);
	
	List<Map<String, Object> > listPage(JqGridPager jqGridPager);
	
	
	List<RoomUser> listUser(JqGridPager jqGridPager);
	
    List<CRoom> list(String where);

    CRoom add(CRoom cRoom) throws Exception;

    void delete(Long id);

    void update(CRoom cRoom) throws Exception;

    void delete(List<Long> ids);

    CRoom get(Long id);

	Map<String, Object> updateMethod(CRoom cRoom);

	Map<String, Object> deleteMethod(String ids, String communityid) throws ExcelException;
	
	Map<String, Object> deleteUser(String id);


	/** 级联楼栋表查询*/
	Map<String, String> getRoom(Long sid);

	Map<String, String> getBySql(Long sid);

	List<Map<String, String>> listBySql(String string);

	Map<String, Object> addMethod(CRoom cRoom);
	
	Map<String, Object> addRoomUser(String communityId, String roomId, String userName, String Tel,String userIdNumber, String status);


	public List<Map<String, Object>> getRoomByUnit(String unitId);

	List<Map<String, Object>> getRoom(String unitId, String roomNo);

	List<Map<String, Object>> queryBySql(String unit, String budingid);
}
